package cn.tedu.boottext33.mapper;

import cn.tedu.boottext33.vo.Mine;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface MineMapper {
    @Insert("insert into mine values(null,#{name},#{job},#{sal})")
    void insert(Mine mine);

    @Delete("delete from mine where id=#{id}")
    void delete(int id);

    @Update("update mine set name=#{name},job=#{job},sal=#{sal} where id=#{id}")
    void update(Mine mine);

    @Select("select * from mine")
    List<Mine> select();
}
